package com.koocloud.electroplatemanage.mapper;

import com.koocloud.electroplatemanage.pojo.PersonMonths;
import com.koocloud.electroplatemanage.pojo.ReportMonth;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.LinkedHashMap;
import java.util.List;

/**
*@Description: 报表Mapper
*@Param: 
*@return: 
*@Author: xxc
*@date: 2020/10/21
*/
@Mapper
public interface StatisticalFormMapper {

    //整体按月完成情况
    List<LinkedHashMap> selectAllByMonthStatus(@Param("startDate")String startDate, @Param("endDate")String endDate);

    //通过图号查单价
    String selectBydrawCodePrice(String drawNoCode);

    //根据图号和工种查工时
    String selectByDrawAndTypeWorkTime(@Param("drawCode")String drawCode, @Param("typeWorkCode")String typeWorkCode);

    //每月工作人数@Param("startDate")String startDate, @Param("endDate")String endDate
    List<LinkedHashMap> selectByMonthPersonqWorkNum();

    //个人按月完成项数、件数、含税总价、工时汇总
    List<LinkedHashMap> selectByMonthPersonStatus(@Param("startDate")String startDate, @Param("endDate")String endDate,@Param("name")String name);

    //单月完成情况
    List<LinkedHashMap> selectByMonthStatus(@Param("year") String year, @Param("month")String month);;
}
